The data that is analyzed in this report is related to road accidents occurring in Geneva. These type of data are usually presented in a table, but there are better ways, such as using maps.
Let’s first look at the overall data with a first overview of the number of accidents by day and year.
| date | groupe_accident | commune | conditions_meteo |
|---|---|---|---|
| 2010-06-16 | Dérapage ou perte de maîtrise | Bernex | Pluie |
| 2010-02-25 | Accident impliquant des piétons | Genève | Beau temps |
| 2010-09-13 | Accident en parquant | Genève | Beau temps |
| 2010-12-06 | Accident en s’engageant sur une route | Carouge | Beau temps |
| 2010-11-04 | Accident en quittant une route | Pregny-Chambésy | Temps couvert |
| 2010-12-26 | Dérapage ou perte de maîtrise | Genthod | Temps couvert |
| 2010-04-09 | Accident par tamponnement | Bernex | Beau temps |
| 2010-08-06 | Dérapage ou perte de maîtrise | Lancy | Beau temps |
| 2010-11-30 | Dérapage ou perte de maîtrise | Genève | Chute de neige |
| 2010-02-01 | Dérapage ou perte de maîtrise | Genève | Beau temps |
| 2010-07-14 | Accident par tamponnement | Versoix | Beau temps |
| 2010-05-19 | Dérapage ou perte de maîtrise | Genève | Beau temps |
| 2010-03-04 | Accident par tamponnement | Genève | Beau temps |
| 2010-03-01 | Dérapage ou perte de maîtrise | Genève | Beau temps |
| 2010-06-20 | Accident par tamponnement | Genève | Beau temps |
Since the information on longitude and latitude is available, it is possible to plot on a graph the exact location of each accident.
An extra layer with Geneva map is added on top of the location.
These set of maps show the location of road accidents in Geneva during the year 2018. But are there more accidents during a rainy day ? Surprisingly the data indicates that accidents are occurring during sunny days.
But let’s look at the number of accidents per year by developing a set of maps that will display accidents by year since 2015.